package cn.pjz.dataUpload.mapper;

import cn.pjz.dataUpload.entity.RTransaction;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface RTransactionMapper extends BaseMapper<RTransaction> {

    void insertBy(@Param("item") RTransaction item);

    String yearByMoney(@Param("year") String year,@Param("id") int id);

    String getYesterdayExpense(@Param("item") String formattedYesterday,@Param("id") int i);

    String getLastMonthExpenditure(@Param("item") String format,@Param("id") int i);

    List<RTransaction> getCountQuantityGoods();

    List<RTransaction> getSelectList(@Param("num") Integer num,@Param("transactionDate") String transactionDate);

    int getSelectListNum();
}
